Dashboard 03 - ZipCode - Creating Line and Clustered Column charts Visualizations - Part 02 18


Step 3:  Create Line and Clustered Column Chart for Average & YOY Apt. Price/Sq. Ft. by Property (Description) Desc.


Visualizations

To create the following visual, copy and paste the Average & YOY House Price/Sq. Ft. by Property Desc visual that was created in Step 1 and use it as a template.


To create a copy of the visual, click the Average & YOY House Price/Sq. Ft. by Property Desc visual , press Ctrl+C to copy, and then press Ctrl+V to paste




Fields

Select the following:

Under Visualizations, drag & drop it in the Shared Axis section:
Type_and_Use ->  Type_Use_Description
DateDimension[Date] ->  Year


Under Visualizations, drag & drop it in the Column Values section:
A_KeyMeasures -> .AVG_AptUnitPrice_PerSqFt%


Under Visualizations, drag & drop it in the Line Values section:
A_KeyMeasures ->  .YOY_AVG_AptUnitPrice_PerSqFt%


Under Visualizations, drag & drop it in the Tooltips section:

A_KeyMeasures ->  .YOY_Diff_AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures ->  .AVG_AptUnitPrice


Note:  Remove any extra filters that are not listed here.


Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:


Type_and_Use ->  Property Type Description
.AVG_AptUnitPrice_PerSqFt% = AVG Apt Price/Sq. Ft.
.YOY_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.YOY_Diff_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.AVG_AptUnitPrice = AVG Apt Price








Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.


Under Format ->  General: X Position = 923 , Y Position = 598 , Width = 576 , Height = 429

Under Format -> Legend ->  Set it to ON , Position = Top Center , Title = OFF , Color = #000000 , Legend Name = [blank] , Font Family = Segoe UI , Text Size = 13 pt , Style = Markers Only

Under Format -> X Axis -> Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Start = 25 ,  Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Gridlines = ON , Line Color = #000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = #5B8F22 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors ->

YOY AVG Apt Price/Sq. Ft. = #1D0D49

AVG Apt Price/Sq. Ft. = #868291



Under Format ->  Data Labels ->  Set it to ON , Color = #000000 , Display Units = Auto , Value Decimal Places = 0 , Text Size = 14 pt , Font Family = Segoe UI , Show Background = Off ,

Customize Series  = ON ,

(Select AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF) ,

(Select YOY AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)


Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = Average & YOY Apt. Price/Sq. Ft. by Property Desc, Year, Quarter Month , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to ON , Color = #666666 , Radius = 5 px



Step 4 - Configure Filter(s)

Filters

None.

After completing, the visual will look as follows:





Sort visuals


Sort the 2 visuals, in descending order, by:


AVG House Price/Sq. Ft.

AVG Apt Price/Sq. Ft.




When finished, save project.




Creating a Line and Clustered Column Chart in Power BI